Tabela TestTube

Definicja tabeli TestTube

Name

TestTube

Code

TestTube

Comment

Próbówki - tabela slownikowa


Lista kolumn tabeli TestTube

Name

Code

TestTubeID

TestTubeID

Active

Active

TestTubeProducerID

TestTubeProducerID

TestTubeCodeByProducer

TestTubeCodeByProducer

TestTubeTypeID

TestTubeTypeID

TestTubeColorID

TestTubeColorID

Volume

Volume

UnitID

UnitID


Kolumna TestTubeID tabeli TestTube

Definicja kolumny TestTubeID tabeli TestTube

Name

TestTubeID

Code

TestTubeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli TestTube

Definicja kolumny Active tabeli TestTube

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna TestTubeProducerID tabeli TestTube

Definicja kolumny TestTubeProducerID tabeli TestTube

Name

TestTubeProducerID

Code

TestTubeProducerID

Data Type

NUMBER(10)

Mandatory

No

Comment

producent próbówek z nowego slownika prodcuentów (-992)


Kolumna TestTubeCodeByProducer tabeli TestTube

Definicja kolumny TestTubeCodeByProducer tabeli TestTube

Name

TestTubeCodeByProducer

Code

TestTubeCodeByProducer

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna TestTubeTypeID tabeli TestTube

Definicja kolumny TestTubeTypeID tabeli TestTube

Name

TestTubeTypeID

Code

TestTubeTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

typ próbówki z nowego slownika (-991)


Kolumna TestTubeColorID tabeli TestTube

Definicja kolumny TestTubeColorID tabeli TestTube

Name

TestTubeColorID

Code

TestTubeColorID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolor próbówki z nowego slownika (-993)


Kolumna Volume tabeli TestTube

Definicja kolumny Volume tabeli TestTube

Name

Volume

Code

Volume

Data Type

NUMBER(14,4)

Mandatory

No

Comment

objetosc próbówki


Kolumna UnitID tabeli TestTube

Definicja kolumny UnitID tabeli TestTube

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki miary z tabeli Unit


Lista kluczy tabeli TestTube

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TestTube

Definicja klucza Identifier_1 tabeli TestTube

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment